This appendix contains sample Job Cost reports.
Date 05/28/2019 Time 14:47:48 XYZ Company Report #0150 Page 0001
C O S T C A T E G O R Y L I S T
Level: The level is determined by the program, based on the group categories on file.
------------------------------------------------------------------------------------------------------------------------------------
Category-# Level Description Cost-type Unit Default Default Default
rate vendor retnge-pct
------------------------------------------------------------------------------------------------------------------------------------
1 1 Contract Requirements *GROUP* End Group #: 9999
1012 2 Lumber MATL
1022 2 Penny Nails MATL
1032 2 Door Hinges MATL
1042 2 Door Knobs MATL
2015 2 Equipment EQPT
2022 2 Light Fixtures MATL
2032 2 Wiring MATL
2042 2 Elec. Tape MATL
6000 2 Legal *GROUP* End Group #: 6999
6108 3 Performance bonds ADMN
6508 3 Insurance ADMN
6608 3 City building permits ADMN
10000 1 General Requirements *GROUP* End Group #: 14999
10500 2 Supervision *GROUP* End Group #: 10599
10511 3 Site foreman LABOR HOUR 15.50
15000 1 Construction Facilities *GROUP* End Group #: 15999
15100 2 Utilities *GROUP* End Group #: 15199
15112 3 Temporary water MATL
15122 3 Temporary Electricity MATL
15132 3 Temporary toilet MATL
15600 2 Maintenance *GROUP* End Group #: 15699
15601 3 Construction clean-up LABOR
15651 3 Laborers - miscellaneous LABOR HOUR 8
20000 1 Site work *GROUP* End Group #: 29999
22000 2 Earthwork *GROUP* End Group #: 22999
22201 3 Excavation - labor LABOR HOUR 14.60
22202 3 Excavation - material MATL
22205 3 Excavation - equipment EQPT HOUR 20
30000 1 Concrete *GROUP* End Group #: 39999
31000 2 Concrete formwork *GROUP* End Group #: 31999
Date 05/28/2019 Time 14:47:48 XYZ Company Report #0150 Page 0002
C O S T C A T E G O R Y L I S T
------------------------------------------------------------------------------------------------------------------------------------
Category-# Level Description Cost-type Unit Default Default Default
rate vendor retnge-pct
------------------------------------------------------------------------------------------------------------------------------------
31001 3 Structural concrete-labor LABOR HOUR 14.50
33102 2 Structural concrete-matl MATL
33105 2 Structural concrete-equip EQPT
50000 1 Metals *GROUP* End Group #: 59999
51000 2 Structural metal framing *GROUP* End Group #: 51999
51203 3 Structural steel - sub SUB BINGHM 10.0
54000 2 Structural siding *GROUP* End Group #: 54999
54603 3 Sheetmetal/roofing - sub SUB BINGHM 10.0
80000 1 Doors and Windows *GROUP* End Group #: 89999
81000 2 Industrial *GROUP* End Group #: 84999
81002 3 Steel doors - industrial MATL EACH 220
81011 3 Doors - labor LABOR HOUR 12
83002 3 Special doors MATL
90000 1 Finishes *GROUP* End Group #: 99999
99400 2 Waterproofing *GROUP* End Group #: 99499
99491 3 Waterproofing - labor LABOR
99492 3 Waterproofing - material MATL
100000 2 Labor Burden LABOR
400000 2 Profit PFT
600000 2 Overhead Burden OVHD
51 categories printed
-- End of report --
Date 06/01/2019 Time 12:09:34 XYZ Company Report #0155 Page 0001
J O B C H A N G E L O G
Stat (job status): N = New I = In-progress A = active C = closed O = copy only U = Unreconciled
Typ (job billing type) : F = fixed-fee P = cost-plus
Burden type: J = % job cost L = % labor cost R = rate per labor hour (number after the type is the burden rate)
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Price Stat Sub-jobs? Bill-subs? Lab-burden Ovhd-catgry Amt-billed Bill-dat Ret-billed
Customer name Cust-# Type Bill-acct OH-burden Retnge-% Amt-paid Pmnt-dat Ret-paid
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 85,689 N N 600000
Brickyards MARIN P 2700-000 L 10.000 10.0
Changed by: RWA on 06/01/19 to become
602 Storage Warehouse 85,869 N N 600000
***********
Brickyards MARIN P 2700-000 L 10.000 10.0
------------------------------------------------------------------------------------------------------------------------------------
1 Changes on file
-- End of report --
Date 06/01/2019 Time 12:30:26 XYZ Company Report #0158 Page 0001
J O B A C T I V A T I O N R E P O R T
Job 603 Second brickyard job - Could not be activated - the following errors were encountered:
Job 603 Second brickyard job - Budgeted amounts of cost items do not equal job price
Price = 85,896 Budget 450
Job 603 Second brickyard job - The overhead burden cost item was not found - category 600000
-- End of report --
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0001
J O B S L I S T
Selections for this print-out:
1. Starting job “First”
2. Ending job “Last”
3. Sub-job All
4. Change order All
5. Starting category “First”
6. Ending category “Last”
7. Job status All
8. Job billing type All
9. Show costs and quantities ? Y
10. Show additional descriptions ? N
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0001
J O B S L I S T
Stat (job status): N = new I = in-progress A = active C = closed O = copy only U = unreconciled
Type (job billing type) : F = fixed-fee P = cost-plus
Burden type: J = % job cost L = % labor cost R = rate per labor hour (number after the type is the burden rate)
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Price Stat Sub-jobs? Bill-subs? Lab-burden Ovhd-catgry Amt-billed Bill-dat Ret-billed
Customer name Cust-# Type Bill-acct OH-burden Retnge-% Amt-paid Pmnt-dat Ret-paid
------------------------------------------------------------------------------------------------------------------------------------
99 Kitchen Cabinets 8,000 A N R 15.000 600000 4,000.00 11/13/18
Neptune Underwater Supply 100 P 2700-000 J 10.000
Cost-item Description Type Unit Rate Vendor Cost-acct Budg-cost Budg-qty Budg-hrs Ret
1012-000-000 Lumber MATL 1450-000 3,200 0
Pct cmp: 75 Cst PTD: 2,000.00
Cst dat: 11/13/18 Cst JTD: 2,000.00
Est dat: 11/13/18
1022-000-000 Penny Nails MATL 1450-000 42 0
Pct cmp: 100 Cst PTD: 32.00
Cst dat: 11/13/18 Cst JTD: 32.00
Est dat: 11/13/18
1032-000-000 Door Hinges MATL 1450-000 250 0
Pct cmp: 100 Cst PTD: 235.00
Cst dat: 11/13/18 Cst JTD: 235.00
Est dat: 11/13/18
1042-000-000 Door Knobs MATL 1450-000 475 0
Pct cmp: 100 Cst PTD: 472.00
Cst dat: 11/13/18 Cst JTD: 472.00
Est dat: 11/13/18
2015-000-000 Equipment EQPT 1450-000 250 0
Pct cmp: 100 Cst PTD: 260.00
Cst dat: 11/13/18 Cst JTD: 260.00
Est dat: 11/13/18
2022-000-000 Light Fixtures MATL 1450-000 655 0
Pct cmp: 100 Cst PTD: 675.00
Cst dat: 11/13/18 Cst JTD: 675.00
Est dat: 11/13/18
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0002
J O B S L I S T
Cost-item Description Type Unit Rate Vendor Cost-acct Budg-cost Budg-qty Budg-hrs Ret
2032-000-000 Wiring MATL 1450-000 125 0
Pct cmp: 100 Cst PTD: 123.00
Cst dat: 11/13/18 Cst JTD: 123.00
Est dat: 11/13/18
2042-000-000 Elec. Tape MATL 1450-000 23 0
Pct cmp: 100 Cst PTD: 27.50
Cst dat: 11/13/18 Cst JTD: 27.50
Est dat: 11/13/18
100000-000-000 Labor Burden LABOR 1450-000 0 320.00
Pct cmp: 100 Cst PTD: 2,100.00 Lab hrs PTD: 300.00
Cst dat: 11/13/18 Cst JTD: 2,100.00 Lab hrs JTD: 300.00
Est dat: 11/13/18 Lab cst PTD: 2,100.00
Lab cst JTD: 2,100.00
400000-000-000 Profit PFT 2,000 0
Cst PTD: .00
Cst JTD: .00
600000-000-000 Overhead Burden OVHD 980 0
Cst PTD: 592.45
Cst JTD: 592.45
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0003
J O B S L I S T
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Price Stat Sub-jobs? Bill-subs? Lab-burden Ovhd-catgry Amt-billed Bill-dat Ret-billed
Customer name Cust-# Type Bill-acct OH-burden Retnge-% Amt-paid Pmnt-dat Ret-paid
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 85,869 A N 600000
Brickyards MARIN P 2700-000 L 10.000 10.0
Cost-item Description Type Unit Rate Vendor Cost-acct Budg-cost Budg-qty Budg-hrs Ret
6108-000-000 Performance bonds ADMN 1450-000 3,594 0
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat:
10511-000-000 Site foreman LABOR HOUR 15.50 1450-000 6,231 0 402.00
Pct cmp: 0 Cst PTD: .00 Lab hrs PTD: .00
Cst dat: Cst JTD: .00 Lab hrs JTD: .00
Est dat: Lab cst PTD: .00
Lab cst JTD: .00
15122-000-000 Temporary Electricity MATL 1450-000 7,854 0
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat:
22205-000-000 Excavation - equipment EQPT HOUR 20.00 TYSON 1450-000 450 22.50
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat: Qty PTD: 0
Qty JTD: 0
33102-000-000 Structural concrete-matl MATL 1450-000 4,549 0
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat:
33105-000-000 Structural concrete-equip EQPT 1450-000 7,694 0
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat:
51203-000-000 Structural steel - sub SUB BINGHM 1450-000 42,097 0 10.
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat:
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0004
J O B S L I S T
Cost-item Description Type Unit Rate Vendor Cost-acct Budg-cost Budg-qty Budg-hrs Ret
81002-000-000 Steel doors - industrial MATL EACH 220.00 1450-000 2,200 10
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat: Qty PTD: 0
Qty JTD: 0
81011-000-000 Doors - labor LABOR HOUR 12.00 1450-000 10,000 0 833.00
Pct cmp: 0 Cst PTD: .00 Lab hrs PTD: .00
Cst dat: Cst JTD: .00 Lab hrs JTD: .00
Est dat: Lab cst PTD: .00
Lab cst JTD: .00
600000-000-000 Overhead Burden OVHD 1,200 0
Cst PTD: .00
Cst JTD: .00
Date 06/01/2019 Time 12:39:50 XYZ Company Report #0160 Page 0005
J O B S L I S T
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Price Stat Sub-jobs? Bill-subs? Lab-burden Ovhd-catgry Amt-billed Bill-dat Ret-billed
Customer name Cust-# Type Bill-acct OH-burden Retnge-% Amt-paid Pmnt-dat Ret-paid
------------------------------------------------------------------------------------------------------------------------------------
603 Second brickyard job 85,896 N N 600000
Curtis Corp CURTIS F 2700-000 J 10.000 10.0
Cost-item Description Type Unit Rate Vendor Cost-acct Budg-cost Budg-qty Budg-hrs Ret
22205-000-000 Excavation - equipment EQPT HOUR 20.00 TYSON 1450-000 450 22.50
Pct cmp: 0 Cst PTD: .00
Cst dat: Cst JTD: .00
Est dat: Qty PTD: 0
Qty JTD: 0
-- End of report --
Date 06/01/2019 Time 13:07:38 XYZ Company Report #0161 Page 0001
C O S T I N G E D I T L I S T
In order by job Starting job: “First” Starting date: “Earliest”
Ending job: “Last” Ending date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Job-# Cost-item Description Entry-date Vnd/Emp Cost Doc-# Lab-hours Calc-burden
Reference Cost-type Unit Quantity Retainage
------------------------------------------------------------------------------------------------------------------------------------
602 6108-000-000 Performance bonds 06/01/19 SMYTHE 4,500.00 0100237
Ten percent bond ADMN 0
Distributions: DR or CR Acct-# Distrib-amt
C 2000-000 Accounts payable 4,500.00
D 1450-000 Cost of jobs 4,500.00
Job totals: 1 entries 4,500.00
Grand totals: 1 entries 4,500.00
Date 06/01/2019 Time 13:07:38 XYZ Company Report #0161 Page 0002
C O S T I N G E D I T L I S T
---------------G/L account distribution totals----------------
4,500.00 credited to 2000-000 Accounts payable
4,500.00 debited to 1450-000 Cost of jobs
-- End of report --
Date 06/01/2019 Time 13:14:58 XYZ Company Report #0163 Page 0001
C O S T I N G R E G I S T E R
Cutoff date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Job-# Cost-item Description Entry-date Vnd/Emp Cost Doc-# Lab-hours Calc-burden
Reference Cost-type Unit Quantity Retainage
------------------------------------------------------------------------------------------------------------------------------------
602 6108-000-000 Performance bonds 06/01/19 SMYTHE 4,500.00 0100237
Ten percent bond ADMN 0
Distributions: DR or CR Acct-# Distrib-amt
C 2000-000 Accounts payable 4,500.00
D 1450-000 Cost of jobs 4,500.00
Job totals: 1 entries 4,500.00
Grand totals: 1 entries 4,500.00
Date 06/01/2019 Time 13:14:58 XYZ Company Report #0163 Page 0002
C O S T I N G R E G I S T E R
---------------G/L account distribution totals----------------
4,500.00 credited to 2000-000 Accounts payable
4,500.00 debited to 1450-000 Cost of jobs
-- End of report --
Date 06/01/2019 Time 13:34:10 XYZ Company Report #0164 Page 0001
B I L L I N G A N D P A Y M E N T E D I T L I S T
Cut-off date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Date Type Doc-# Reference Amount
Sub-job # Cus-# Customer-name Retainage
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 06/01/19 Billing 1466 First progress billing 28,500.00
MARIN Brickyards 2,850.00
Distributions: DR or CR Acct-# Distrib-amt
D 1100-000 Accounts receivable 25,650.00
C 2700-000 Billings on jobs 28,500.00
D 1105-000 Retainage receivable 2,850.00
1 Billings Billing total: 28,500.00 Billing retainage: 2,850.00
--
1 Entries
Date 06/01/2019 Time 13:34:10 XYZ Company Report #0164 Page 0002
B I L L I N G A N D P A Y M E N T E D I T L I S T
---------------G/L account distribution totals--------------
28,500.00 credited to 2700-000 Billings on jobs
25,650.00 debited to 1100-000 Accounts receivable
2,850.00 debited to 1105-000 Retainage receivable
---------
28,500.00 total debited
-- End of report --
Date 06/01/2019 Time 13:35:11 XYZ Company Report #0165 Page 0001
B I L L I N G A N D P A Y M E N T R E G I S T E R
Cut-off date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Job-# Title Date Type Doc-# Reference Amount
Sub-job # Cus-# Customer-name Retainage
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 06/01/19 Billing 1466 First progress billing 28,500.00
MARIN Brickyards 2,850.00
Distributions: DR or CR Acct-# Distrib-amt
D 1100-000 Accounts receivable 25,650.00
C 2700-000 Billings on jobs 28,500.00
D 1105-000 Retainage receivable 2,850.00
1 Billings Billing total: 28,500.00 Billing retainage: 2,850.00
--
1 Entries
Date 06/01/2019 Time 13:35:11 XYZ Company Report #0165 Page 0002
B I L L I N G A N D P A Y M E N T R E G I S T E R
---------------G/L account distribution totals--------------
28,500.00 credited to 2700-000 Billings on jobs
25,650.00 debited to 1100-000 Accounts receivable
2,850.00 debited to 1105-000 Retainage receivable
---------
28,500.00 total debited
-- End of report --
Completion Estimates Edit List
Date 06/01/2019 Time 14:19:34 XYZ Company Report #0166 Page 0001
C O M P L E T I O N E S T I M A T E S E D I T L I S T
------------------------------------------------------------------------------------------------------------------------------------
Job-# Job title Cost item Description Estimate Outstanding Pct Cost Unit/Hrs
date P.O.’s compl to-compl to-compl
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 10511-000-000 Site foreman 6/01/19 0 0.000 0 40
1 entry
-- End of report --
Date 06/01/2019 Time 14:19:55 XYZ Company Report #0167 Page 0001
C O M P L E T I O N E S T I M A T E S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Job-# Job title Cost item Description Estimate Outstanding Pct Cost Unit/Hrs
date P.O.’s compl to-compl to-compl
------------------------------------------------------------------------------------------------------------------------------------
602 Storage Warehouse 10511-000-000 Site foreman 6/01/19 0 0.000 0 40
1 entry
-- End of report --
Date 06/01/2019 Time 14:28:15 XYZ Company Report #0168 Page 0001
J O B I N S P E C T I O N W O R K S H E E T
Job: 99 Kitchen Cabinets Prev-%-compl: 0 As of: New-%-compl: .....
Inspected by: ............... Approved by: ............... Comments: .........................................
Date: .......... Date: .......... .........................................
------------------------------------------------------------------------------------------------------------------------------------
Categry Type Unit ---------------------- Cost ---------------------- ------ Units/Hours ------ Pct Cost to Units to
Description Budget Period Total Open P.O.’s Budget Period Total compl complete complete
------------------------------------------------------------------------------------------------------------------------------------
1012 MATL 3,200 2,000 2,000 ........... ... ............ .......
Lumber
1022 MATL 42 32 32 ........... ... ............ .......
Penny Nails
1032 MATL 250 235 235 ........... ... ............ .......
Door Hinges
1042 MATL 475 472 472 ........... ... ............ .......
Door Knobs
2015 EQPT 250 260 260 ........... ... ............ .......
Equipment
2022 MATL 655 675 675 ........... ... ............ .......
Light Fixtures
2032 MATL 125 123 123 ........... ... ............ .......
Wiring
2042 MATL 23 28 28 ........... ... ............ .......
Elec. Tape
100000 LABOR 2,100 2,100 ........... 320 300 300 ... ............ .......
Labor Burden
400000 PFT 2,000 ........... ... ............ .......
Profit
600000 OVHD 980 592 592 ........... ... ............ .......
Overhead Burden
Date 06/01/2019 Time 14:28:15 XYZ Company Report #0168 Page 0002
J O B I N S P E C T I O N W O R K S H E E T
Job: 602 Storage Warehouse Prev-%-compl: 0 As of: New-%-compl: .....
Inspected by: ............... Approved by: ............... Comments: .........................................
Date: .......... Date: .......... .........................................
------------------------------------------------------------------------------------------------------------------------------------
Categry Type Unit ---------------------- Cost ---------------------- ------ Units/Hours ------ Pct Cost to Units to
Description Budget Period Total Open P.O.’s Budget Period Total compl complete complete
------------------------------------------------------------------------------------------------------------------------------------
6108 ADMN 3,594 4,500 4,500 ........... ... ............ .......
Performance bonds
10511 LABOR HOUR 6,231 ........... 402 ... ............ .......
Site foreman
15122 MATL 7,854 ........... ... ............ .......
Temporary Electricity
22205 EQPT HOUR 450 ........... 22 ... ............ .......
Excavation - equipment
33102 MATL 4,549 ........... ... ............ .......
Structural concrete-matl
33105 EQPT 7,694 ........... ... ............ .......
Structural concrete-equip
51203 SUB 42,097 ........... ... ............ .......
Structural steel - sub
81002 MATL EACH 2,200 ........... 10 ... ............ .......
Steel doors - industrial
81011 LABOR HOUR 10,000 ........... 833 ... ............ .......
Doors - labor
600000 OVHD 1,200 ........... ... ............ .......
Overhead Burden
Date 06/01/2019 Time 14:28:15 XYZ Company Report #0168 Page 0003
J O B I N S P E C T I O N W O R K S H E E T
Job: 603 Second brickyard job Prev-%-compl: 0 As of: New-%-compl: .....
Inspected by: ............... Approved by: ............... Comments: .........................................
Date: .......... Date: .......... .........................................
------------------------------------------------------------------------------------------------------------------------------------
Categry Type Unit ---------------------- Cost ---------------------- ------ Units/Hours ------ Pct Cost to Units to
Description Budget Period Total Open P.O.’s Budget Period Total compl complete complete
------------------------------------------------------------------------------------------------------------------------------------
22205 EQPT HOUR 450 ........... 22 ... ............ .......
Excavation - equipment
-- End of report --
Date 06/01/2019 Time 17:02:29 XYZ Company Report #0174 Page 0001
J O B S T A T U S
Selections for this print-out:
1. Starting job 602 9. Cost types to print:
2. Ending job “Last”
LABOR Yes
3. Sub-job “All” MATL Yes
4. Change order “All” SUB Yes
OVHD Yes
5. Starting category “First” EQPT Yes
6. Ending category “Last” LBRD Yes
ADMN Yes
7. Show cost type totals ? Yes PFT Yes
8. Show additional description ? No
10. Cost item detail WITHOUT group sub-totals ? Yes
Cost item detail WITH group sub-totals ? No
Group sub-totals ONLY, no cost item detail ? No
Date 06/01/2019 Time 17:02:29 XYZ Company Report #0174 Page 0001
J O B S T A T U S
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description ---------- Actual costs ---------- --- Estimates ---- ------ Projections ---------
Type Unit Budgeted Job-to-dat Total Pct Cost Tot-cost Pct Cost
Outstd-PO Prd-to-dat compl to-compl -- Over/(under) -
------------------------------------------------------------------------------------------------------------------------------------
Job: 602 Storage Warehouse Cost-plus Customer: MARIN Brickyards Active
6108-000-000 Performance bonds 3,594 4,500 4,500 0.000 3,594 8,094 125 4,500
ADMN 4,500
10511-000-000 Site foreman 6,231 0.000 620 620 ( 90) ( 5,611)
LABOR HOUR
15122-000-000 Temporary Electricity 7,854 0.000 7,854 7,854
MATL
22205-000-000 Excavation - equipment 450 0.000 450 450
EQPT HOUR
33102-000-000 Structural concrete-matl 4,549 0.000 4,549 4,549
MATL
33105-000-000 Structural concrete-equip 7,694 0.000 7,694 7,694
EQPT
51203-000-000 Structural steel - sub 42,097 974 974 0.000 42,097 43,071 2 974
SUB 974
81011-000-000 Doors - labor 10,000 0.000 10,000 10,000
LABOR HOUR
600000-000-000 Overhead Burden 1,200 0.000 1,200 1,200
OVHD
Cng: 1 Change door
81002-000-001 Steel doors - industrial 100 0.000 100 100
MATL EACH
Job totals - direct costs: 84,769 5,474 5,474 79,158 84,632 ( 137)
5,474
Job totals - non-direct costs: 1,200 1,200 1,200
LABOR: 16,231 10,620 10,620 ( 35) ( 5,611)
MATL: 14,703 14,703 14,703
SUB: 42,097 974 974 42,097 43,071 2 974
(Not a direct cost) OVHD: 1,200 1,200 1,200
EQPT: 8,144 8,144 8,144
Date 06/01/2019 Time 17:02:29 XYZ Company Report #0174 Page 0002
J O B S T A T U S
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description ---------- Actual costs ---------- --- Estimates ---- ------ Projections ---------
Type Unit Budgeted Job-to-dat Total Pct Cost Tot-cost Pct Cost
Outstd-PO Prd-to-dat compl to-compl -- Over/(under) -
------------------------------------------------------------------------------------------------------------------------------------
Job: 602 Storage Warehouse
ADMN: 3,594 4,500 4,500 3,594 8,094 125 4,500
Date 06/01/2019 Time 17:02:29 XYZ Company Report #0174 Page 0003
J O B S T A T U S
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description ---------- Actual costs ---------- --- Estimates ---- ------ Projections ---------
Type Unit Budgeted Job-to-dat Total Pct Cost Tot-cost Pct Cost
Outstd-PO Prd-to-dat compl to-compl -- Over/(under) -
------------------------------------------------------------------------------------------------------------------------------------
Job: 603 Second brickyard job Fixed-fee Customer: CURTIS Curtis Corp New
22205-000-000 Excavation - equipment 450 0.000 450 450
EQPT HOUR
Job totals: 450 450 450
EQPT: 450 450 450
Grand totals - direct costs: 85,219 5,474 5,474 79,608 85,082 ( 137)
5,474
Grand totals - non-direct costs: 1,200 1,200 1,200
LABOR: 16,231 10,620 10,620 ( 35) ( 5,611)
MATL: 14,703 14,703 14,703
SUB: 42,097 974 974 42,097 43,071 2 974
(Not a direct cost) OVHD: 1,200 1,200 1,200
EQPT: 8,594 8,594 8,594
ADMN: 3,594 4,500 4,500 3,594 8,094 125 4,500
** WARNING - GRAND TOTALS INCLUDE JOBS WHICH ARE NOT ACTIVE OR CLOSED **
-- End of report --
Date 06/02/2019 Time 13:41:53 XYZ Company Report #0175 Page 0001
P E R F O R M A N C E
Selections for this print-out:
1. Starting job 602 7. Cost types to print
2. Ending job “Last”
LABOR Y
3. Sub-job All MATL Y
SUB Y
4. Starting category “First” OVHD Y
5. Ending category 170000 EQPT Y
LBRD Y
6. Show only poor performance ? N ADMN Y
PFT Y
Date 06/02/2019 Time 13:41:53 XYZ Company Report #0175 Page 0001
P E R F O R M A N C E
Actual rate is based on total cost and total quantity.
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description Type Qty-% Budg-qty Qty-PTD Tot-qty Act-rate Cst-date Proj-qty
Unit Vendor Est-% Budg-cost Cost-PTD Tot-cost Exp-rate Est-date Proj-cost
------------------------------------------------------------------------------------------------------------------------------------
Job: 602 Storage Warehouse
6108-000-000 Performance bonds ADMN 0 0 0 06/01/19
3,594 4,500 4,500
10511-000-000 Site foreman LABOR 0 0 0
HOUR 6,231 06/01/19
15122-000-000 Temporary Electricity MATL 0 0 0
7,854
22205-000-000 Excavation - equipment EQPT 22.50 0 0
HOUR TYSON 450 20.00
33102-000-000 Structural concrete-matlMATL 0 0 0
4,549
33105-000-000 Structural concrete-equiEQPT 0 0 0
7,694
51203-000-000 Structural steel - sub SUB 0 0 0 06/01/19
BINGHM 42,097 974 974
81002-000-000 Steel doors - industrialMATL 10 0 0
EACH 2,200 220.00
81011-000-000 Doors - labor LABOR 0 0 0
HOUR 10,000
Cng: 1 Change door
81002-000-001 Steel doors - industrialMATL 0.40 0 0
EACH 100 250.00
Date 06/02/2019 Time 13:41:53 XYZ Company Report #0175 Page 0002
P E R F O R M A N C E
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description Type Qty-% Budg-qty Qty-PTD Tot-qty Act-rate Cst-date Proj-qty
Unit Vendor Est-% Budg-cost Cost-PTD Tot-cost Exp-rate Est-date Proj-cost
------------------------------------------------------------------------------------------------------------------------------------
Job: 603 Second brickyard job
22205-000-000 Excavation - equipment EQPT 22.50 0 0
HOUR TYSON 450 20.00
-- End of report --
Date 06/02/2019 Time 13:43:57 XYZ Company Report #0176 Page 0001
L A B O R A N A L Y S I S
Selections for this print-out:
1. Starting job 602
2. Ending job “Last”
3. Sub-job “All”
4. Starting category “First”
5. Ending category 520000
6. Show only poor performance ? No
Date 06/02/2019 Time 13:43:57 XYZ Company Report #0176 Page 0001
L A B O R A N A L Y S I S
------------------------------------------------------------------------------------------------------------------------------------
--------------Actual-------------- --------------Projected--------------
Cost-item Budgeted Regular Premium Burden Pct-cmpl Cost Burden Var-% Var-amt
Description cost/hrs cost/hrs cost/hrs cost cost/est Hours ----cost/hrs----
------------------------------------------------------------------------------------------------------------------------------------
Job: 602 Storage Warehouse
10511-000-000 6,231 6,231
Site foreman 402.0 402.0
10500 *Group* 6,231 6,231
Supervision 402.0 402.0
10000 *Group* 6,231 6,231
General Requirements 402.0 402.0
81011-000-000 10,000 10,000
Doors - labor 833.0 833.0
81000 *Group* 10,000 10,000
Industrial 833.0 833.0
80000 *Group* 10,000 10,000
Doors and Windows 833.0 833.0
-- End of report --
Date 06/02/2019 Time 13:45:44 XYZ Company Report #0177 Page 0001
P R O F I T A B I L I T Y
Job 602 Storage Warehouse Active
ESTIMATED PROFITABILITY AT COMPLETION PROFIT/(LOSS)
------------------------------------- -------------
Price including changes 85,969 Earned to-date 9
Actual cost-to-date 5,474 Previously recognized
Estimated cost at completion 85,832 -----------
Estimated profit/(loss) at completion 137 To be recognized 9
REVENUE BILLED TO-DATE
------- --------------
Earned revenue 5,483 Amount billed 28,539
Billings over cost 23,056
Cost over billings
CURRENT BILLING RESULT OF CURRENT BILLING
--------------- -------------------------
Amount to be billed _______________ Billings over cost _______________
Cost over billings _______________
Date 06/02/2019 Time 13:45:44 XYZ Company Report #0177 Page 0002
P R O F I T A B I L I T Y
Job range: 602 to “Last”
Job bill type: Both fixed fee and cost-plus jobs
Job status: Active, closed and in-progress jobs
** TOTALS FOR ALL JOBS **
ESTIMATED PROFITABILITY AT COMPLETION PROFIT/(LOSS)
------------------------------------- -------------
Price including changes 85,969 Earned to-date 9
Actual cost-to-date 5,474 Previously recognized
Estimated cost at completion 85,832 --------------
Estimated pft/(loss) at completion 137 To be recognized 9
REVENUE BILLED TO-DATE
------- --------------
Earned revenue 5,483 Amount billed 28,539
Billings over cost 23,056
Cost over billings
CURRENT BILLING RESULT OF CURRENT BILLING
--------------- -------------------------
Amount to be billed _______________ Billings over cost _______________
Cost over billings _______________
-- End of report --
Date 06/02/2019 Time 13:49:56 XYZ Company Report #0178 Page 0001
C O S T S B Y J O B
Selections for this print-out:
1. Starting job 602 9. Cost types to print
2. Ending job “Last”
LABOR Y
3. Sub-job All MATL Y
4. Change order All SUB Y
OVHD Y
5. Starting category “First” EQPT Y
6. Ending category 170000 LBRD Y
ADMN Y
7. Starting date “Earliest” PFT Y
8. Ending date “Latest”
10. 1 or 2 line format ? 2
Date 06/02/2019 Time 13:49:56 XYZ Company Report #0178 Page 0001
C O S T S B Y J O B
Hrs/Ret - for a labor entry, this is hours. Otherwise, it is retainage.
------------------------------------------------------------------------------------------------------------------------------------
Cost-item Description Type Date Cost-amount Quantity Doc-# Hrs/Ret Chk-date Chk-#
Reference Src Vend/Emp Unit
------------------------------------------------------------------------------------------------------------------------------------
Job 602 Storage Warehouse
6108-000-000 Performance bonds ADMN 06/01/19 4,500.00 0 100237
Ten percent bond J/C SMYTHE
51203-000-000 Structural steel - sub SUB 06/01/19 974.00 0 4937 97.40
J/C BINGHM
Job 602 totals: 2 entries 5,474.00 Ret 97.40
Report totals: 2 entries 5,474.00 Ret 97.40
-- End of report --
Date 06/02/2019 Time 13:50:31 XYZ Company Report #0179 Page 0001
B I L L I N G S / P A Y M E N T S B Y J O B #
Job number order Starting job: 602 Sub-job: All Starting date: “Earliest”
Ending job: “Last” Ending date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Amount Apply-to Reference-1 Reference-2 Retainage
------------------------------------------------------------------------------------------------------------------------------------
Job: 602 Storage Warehouse
06/01/19 BILLING 1466 28,500.00 First progress billing 2,850.00
06/01/19 BILLING 93473 39.00 3.90
Job 602 totals:
2 billing entries 28,539.00 2,853.90
Report totals:
2 billing entries 28,539.00 2,853.90
------
2 entries
-- End of report --
Date 06/02/2019 Time 13:51:10 XYZ Company Report #0180 Page 0001
J O B S U M M A R Y
Job: 602 Storage Warehouse
------------------------------------------------------------------------------------------------------------------------------------
Group-# Description Price ------- Actual cost -------- Pct Bal-to-compl To be billed
incl-chngs This-period Job-to-date Compl
------------------------------------------------------------------------------------------------------------------------------------
1 Contract Requirements 3,594 4,500.00 4,500.00 125.2 .00 _____________
10000 General Requirements 6,231 .00 .00 0.0 6,231.00 _____________
15000 Construction Facilities 7,854 .00 .00 0.0 7,854.00 _____________
20000 Site work 450 .00 .00 0.0 450.00 _____________
30000 Concrete 12,243 .00 .00 0.0 12,243.00 _____________
50000 Metals 42,097 974.00 974.00 2.3 41,123.00 _____________
80000 Doors and Windows 12,300 .00 .00 0.0 12,300.00 _____________
600000 Overhead Burden 1,200 .00 .00 0.0 1,200.00 _____________
Totals: 85,969 5,474.00 5,474.00 6.4 80,495.00 _____________
-- End of report --
Date 06/02/2019 Time 14:06:59 XYZ Company Report #0181 Page 0001
C O S T C A T E G O R Y A N A L Y S I S
------------------------------------------------------------------------------------------------------------------------------------
Category Description Type Unit Prd-to-date Last-prd Year-to-date
------------------------------------------------------------------------------------------------------------------------------------
1012 Lumber MATL Cost: 2,000.00 .00 2,000.00
1022 Penny Nails MATL Cost: 32.00 .00 32.00
6608 City building permits ADMN Cost: .00 .00 .00
10511 Site foreman LABOR HOUR Cost: .00 .00 .00
Units: 0 0 0
Cost/unit:
Hours:
Hrs/unit:
Units/hr:
Cost/hr:
15112 Temporary water MATL Cost: .00 .00 .00
Date 06/02/2019 Time 14:06:59 XYZ Company Report #0181 Page 0002
C O S T C A T E G O R Y A N A L Y S I S
------------------------------------------------------------------------------------------------------------------------------------
Category Description Type Unit Prd-to-date Last-prd Year-to-date
------------------------------------------------------------------------------------------------------------------------------------
15122 Temporary Electricity MATL Cost: .00 .00 .00
15132 Temporary toilet MATL Cost: .00 .00 .00
15601 Construction clean-up LABOR Cost: .00 .00 .00
Hours:
Cost/hr:
15651 Laborers - miscellaneous LABOR HOUR Cost: .00 .00 .00
Units: 0 0 0
Cost/unit:
Hours:
Hrs/unit:
Units/hr:
Cost/hr:
22201 Excavation - labor LABOR HOUR Cost: .00 .00 .00
Units: 0 0 0
Cost/unit:
Hours:
Hrs/unit:
Units/hr:
Cost/hr:
Date 06/02/2019 Time 14:06:59 XYZ Company Report #0181 Page 0004
C O S T C A T E G O R Y A N A L Y S I S
------------------------------------------------------------------------------------------------------------------------------------
Category Description Type Unit Prd-to-date Last-prd Year-to-date
------------------------------------------------------------------------------------------------------------------------------------
600000 Overhead Burden OVHD Cost: 592.45 .00 592.45
33 categories printed
-- End of report --
Job Cost Distributions to General Ledger Report
Date 06/02/2019 Time 14:11:33 XYZ Company Report #0182 Page 0001
J O B C O S T D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Accounts: “First” thru “Last”
Starting date: “Earliest” Ending date: “Latest”
JC = Cost JB = Billing
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description Date Amount Source Posted-to-G/L
------------------------------------------------------------------------------------------------------------------------------------
1100-000 Accounts receivable 11/13/18 4,000.00 JB0191 N
06/01/19 25,650.00 JB0165 N
06/01/19 35.10 JB0173 N
Account 1100-000 Total: 29,685.10
1105-000 Retainage receivable 06/01/19 2,850.00 JB0165 N
06/01/19 3.90 JB0173 N
Account 1105-000 Total: 2,853.90
1450-000 Cost of jobs 11/13/18 3,831.50 JC0188 N
11/13/18 7.00CR JC0189 N
11/13/18 2,100.00 JC0190 N
06/01/19 4,500.00 JC0163 N
06/01/19 974.00 JC0172 N
Account 1450-000 Total: 11,398.50
2000-000 Accounts payable 11/13/18 3,824.50CR JC0188 N
06/01/19 4,500.00CR JC0163 N
06/01/19 876.60CR JC0172 N
Account 2000-000 Total: 9,201.10CR
2005-000 Retainage payable 06/01/19 97.40CR JC0172 N
Account 2005-000 Total: 97.40CR
2010-000 Salaries & wages payable 11/13/18 7.00CR JC0188 N
11/13/18 7.00 JC0189 N
11/13/18 2,100.00CR JC0190 N
Account 2010-000 Total: 2,100.00CR
2700-000 Billings on jobs 11/13/18 4,000.00CR JB0191 N
11/13/18 2,000.00CR JB0192 N
06/01/19 28,500.00CR JB0165 N
06/01/19 39.00CR JB0173 N
Account 2700-000 Total: 34,539.00CR
4000-000 Revenue from jobs 11/13/18 2,000.00 JB0192 N
Account 4000-000 Total: 2,000.00
Date 06/02/2019 Time 14:11:33 XYZ Company Report #0182 Page 0002
J O B C O S T D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description Date Amount Source Posted-to-G/L
------------------------------------------------------------------------------------------------------------------------------------
Total Debits: 45,951.50
Total Credits: 45,951.50CR
-- End of report --
Date 06/02/2019 Time 14:29:02 XYZ Company Report #0183 Page 0001
J O B D E T A I L P U R G E L O G
Starting job: 602 Starting date: “Earliest” Cost entries
Ending job: 602 Ending date: “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Job number Cost item Source Date Doc-# Hours Amount Retainage
Title Description Type ID-# Doc-typ Reference
------------------------------------------------------------------------------------------------------------------------------------
602 6108-000-000 J/C 06/01/19 0100237 .00 4,500.00 .00
Storage Warehouse Performance bonds ADMN Ten percent bond
51203-000-000 J/C 06/01/19 4937 .00 974.00 97.40
Structural steel - sub SUB
-- End of report --